Introduction and Problem Statement
According recent studies, only seven percent of Americans are
satisfied with the current healthcare system.Uneven care has left health
consumers unsatisfied since they are receiving different levels of care
which is determined not by a standardized quality but by their location,
condition, or insurance plan. Rural areas might not have enough
hospitals, while urban cities may have an over flux of healthcare
resources and facilities. This project is an attempt to trace this
disparity in the US Healthcare and answer the underlying questions to
understand and fix this broken system by performing an in depth analysis
to compare metrics in aspect of infrastructure and population of the
states that performing well the states that are lagging in terms of
resources. ###We have used a dataset provided by the Homeland
Infrastructure Foundation-Level Data (HIFLD) that is made available for
Public Use without a license. We have also used supplementary dataset to
get the statewise population data to find the number of beds per 1000
population.
Section 1 - Exploring distribution of statewise availability of
healthcare resources taking the number of beds in hospitals as a
metric
Question 1
What is the state wise distribution of number of hospital beds per
1000 people across the US?
Output 1
The above choropleth map gives insight about Total number of beds
available , ratio of number of beds per 1000 people and total population
for each state. It is inferred from the plot that District columbia has
highest bed ratio followed by North dakota, mississippi, west virginia
and ohio. These states have bed ratio more than 4.5. While new maxico,
washigton, idaho, oregon and colorado are the states having Bed Ratio
less than 2.5. It is also inferred that there are states with
considerable population are doing very good compared to states having
almost same population. We have also found that california one of the
economically best performing state has Bed ratio 2.72 which is
comparatively low.
Question 2
What is the distribution of Bed Ratio across the states for
different types of ownership ?

Output 2
It is found from the chart that Goverment hospitals have very less
no of beds per 1000 people compared to Non profit and Proprietary
hospitals. It is also found that Goverment owned hospitals has almost
same Bed ratio across the states and ownership. Bed ratio for Non profit
Hospitals is largely distributed across the states which shows disparity
in no of beds across the states for Non profit hospitals. For
Proprietary owned hospitals distribution across the states is also
widely distributed. It is clearly seen from the chart that Non profit
hospitals is contributing marginally well compared to other types of
ownership.
Question 3
what is the relationship of Total number of hospitals vs Total
number of beds across every states for the different types of ownership
?

Output -3
It can be inferred from the chart that Non-profit and Proprietary
owned hospitals have more number of beds per hospitals compared to
goverment owned hospitals. It is found that there is wide disparity in
nummber of beds per hospital across the Goverment - district owned
hospitals and Goverment - federal owned hospitals. It shows the
difference in performance of different type of district, state and local
goverment body for Beds per hospitals. The Bed ratio across the states
is also widely scattered for federal goverment owned hospitals.
Section 2 - Analysing contribution of different types of Ownership
Body in US Hospital infrastructure
Question 1
What is percetage distribution of Total number of beds across
different types of ownership for US?

Output 1
It is found that Non profit hospitals have major contrubution in
providing US healthcare infrastructure. Non profit hospitals has highest
contribution in providing Hospitals Beds followed by Proprietary and
goverment owned hospitals. State and federal goverment are doing almost
equallly same.
Question 2
What is percetage distribution of Total number of hospitals for
different hospital types in US?

Output 2
General Acute care type is having highest number of hospitals
followed by Critical Access , Psychiatric and Long term care. The
percentage of Children hospital is only 1.591 % which comparatively very
low. Hospitals specifically dedicated to women and special category are
also the lowest in number across the USA.
Question 3
What is status of hospitals across the US for different ownership
type ?
OUTPUT 3
From the given stacked bar chart, we can infer that Non-profit
organizations have the highest count for hospitals that are open as
compared to other owners. The highest ratio of open to closed hospitals
is of Government Federal- 50:1. All the ownership body is performing
good in terms number of Open Hosptls.